This AgileShape can be used to execute dynamic SQL statements and/or call database stored procedures.
NOTE: This AgileShape is a specialized sub-type of the AgilePart AgileShape. Refer to the documentation for the AgilePart AgileShape for additional information about the properties and behavior that this sub-type inherits from the AgilePart AgileShape.
NOTE: This AgileShape does not support capturing return values or output parameters. Refer to the Query Database AgileShape for additional information about retrieving data from the database.
Design-Time Properties
NOTE: Since this AgileShape is a specialized sub-type of the AgilePart AgileShape, all of the standard properties supported by the AgilePart AgileShape are also supported by this AgileShape. Since they are already documented elsewhere, the standard AgilePart properties are not documented in this section. Refer to the documentation for the AgilePart AgileShape for information about the standard AgilePart properties. Additional design-time properties (other than the standard AgilePart properties) that are specific to this AgileShape are documented below.
Configure
This property allows the process modeler to configure where and how the new database record is inserted into the database.
NOTE: Changes made to this property’s configuration may also update the values of the ConnectionString, and/or SQL properties. Click the Ellipses button to open the configuration dialog (as shown below).
ConnectionString
NOTE: This property can only be updated via the Configure property. See that property for additional information.
The connection string that will be used to connect to the database at runtime.
DatabaseType
The type of database that will be used.
Debug
Default value: True
This property determines whether the AgileShape will log additional progress and debugging messages to the AgilePoint Server log file at runtime. This property can be set to the following specific values:
- False
This value indicates that the AgileShape will not log additional progress and debugging messages to the AgilePoint Server log file at runtime.
- True
This value indicates that the AgileShape will log additional progress and debugging messages to the AgilePoint Server log file at runtime. These messages are often helpful in verifying that the AgileShape is functioning properly and/or with troubleshooting any problems or suspected problems with the AgileShape’s runtime behavior or configuration.
SQL
NOTE: This property can only be updated via the Configure property. See that property for additional information.
The SQL statement that will be performed on the database by this AgileShape at runtime.
Timeout
Default value: 600
Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the Web service call associated with this AgileShape.